#ifndef __INSERTROLEDETAIL_H__
#define __INSERTROLEDETAIL_H__

#include "dbmessage.h"

/**
*@file       insertroledetail.h
*@brief      insert a role detail into the table
*
*@author     graywind
*@version    1.0.0.0
*@data       2012/03/28
*/

class InsertRoleDetail
{
    DeclareMysqlQueryPre(AccountDB);
};
ImplMysqlQueryPre(InsertRoleDetail,
                  "if not exists(select * from role_info where name = '?') begin insert into role_info (usr_id, role_code, name, level, job, gender, graphics, world, detail) values (\"?\", \"?\", \"?\", \"?\", \"?\", \"?\", \"?\", \"?\", \"?\") end");

#endif